<?php
/* -------------------------------------------------------------------------------------
* 	ID:						$Id: countries.php 29 2013-09-21 11:54:19Z phone.mueller@googlemail.com $
* 	Letzter Stand:			$Revision: 29 $
* 	zuletzt geaendert von:	$Author: siekiera $
* 	Datum:					$Date: 2013-09-21 11:54:19 +0000 (Sat, 21 Sep 2013) $
*
* 	SEO:mercari by Siekiera Media
* 	http://www.seo-mercari.de
*
* 	Copyright (c) since 2011 SEO:mercari
* --------------------------------------------------------------------------------------
* 	based on:
* 	(c) 2000-2001 The Exchange Project  (earlier name of osCommerce)
* 	(c) 2002-2003 osCommerce - www.oscommerce.com
* 	(c) 2003     nextcommerce - www.nextcommerce.org
* 	(c) 2005     xt:Commerce - www.xt-commerce.com
*
* 	Released under the GNU General Public License
* ----------------------------------------------------------------------------------- */

require('includes/application_top.php');

if ($_GET['action']) {
	switch ($_GET['action']) {
		case 'insert':
			$countries_name = $_POST['countries_name'];
			$countries_iso_code_2 = $_POST['countries_iso_code_2'];
			$countries_iso_code_3 = $_POST['countries_iso_code_3'];
			$address_format_id = $_POST['address_format_id'];

			$db->db_query("INSERT INTO
								".TABLE_COUNTRIES."
								(countries_name, countries_iso_code_2, countries_iso_code_3, address_format_id)
							VALUES
								(".$db->db_prepare($countries_name).", ".$db->db_prepare($countries_iso_code_2).", ".$db->db_prepare($countries_iso_code_3).", ".$db->db_prepare($address_format_id).")");
			redirect(href_link(FILENAME_COUNTRIES));
		break;

		case 'save':
			$countries_id = $_GET['cID'];
			$countries_name = $_POST['countries_name'];
			$countries_iso_code_2 = $_POST['countries_iso_code_2'];
			$countries_iso_code_3 = $_POST['countries_iso_code_3'];
			$address_format_id = $_POST['address_format_id'];

			$db->db_query("UPDATE
								".TABLE_COUNTRIES."
							SET
								countries_name = ".$db->db_prepare($countries_name).",
								countries_iso_code_2 = ".$db->db_prepare($countries_iso_code_2).",
								countries_iso_code_3 = ".$db->db_prepare($countries_iso_code_3).",
								address_format_id = ".$db->db_prepare($address_format_id)."
							WHERE
								countries_id = ".$db->db_prepare($countries_id));
			redirect(href_link(FILENAME_COUNTRIES, 'page='.$_GET['page'].'&cID='.$countries_id));
		break;

		case 'deleteconfirm':
			$countries_id = $_GET['cID'];

			$db->db_query("DELETE FROM ".TABLE_COUNTRIES." WHERE countries_id = ".$db->db_prepare($countries_id));
			redirect(href_link(FILENAME_COUNTRIES, 'page='.$_GET['page']));
		break;

		case 'setlflag':
			$countries_id = $_GET['cID'];
			$status = $_GET['flag'];
			$db->db_query("UPDATE
								".TABLE_COUNTRIES."
							SET
								status = ".$db->db_prepare($status)."
							WHERE
								countries_id = ".$db->db_prepare($countries_id));
			redirect(href_link(FILENAME_COUNTRIES, 'page='.$_GET['page'].'&cID='.$countries_id));
		break;

		case 'setflag_all':
			$status = $_GET['flag'];
			$db->db_query("UPDATE ".TABLE_COUNTRIES." SET status = ".$db->db_prepare($status));
			redirect(href_link(FILENAME_COUNTRIES, 'page='.$_GET['page']));
		break;
	}
}
require(DIR_WS_INCLUDES.'metatag.php'); ?>
</head>
<body>
<?php require(DIR_WS_INCLUDES.'header.php'); ?>
<div id="wrapper">
<table class="outerTable" cellspacing="0" cellpadding="0">
  <tr>
    <td class="columnLeft2" width="<?php echo BOX_WIDTH; ?>" valign="top">
		<?php require(DIR_WS_INCLUDES.'column_left.php'); ?>
	</td>
    <td class="boxCenter" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
      <tr>
        <td>
			<table class="table_pageHeading" border="0" width="100%" cellspacing="0" cellpadding="0">
	   			<tr>
	     			<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
				</tr>
			</table>
		</td>
      </tr>
	  <tr>
		<td align="right">
			<a class="button" href="<?php echo  href_link(FILENAME_COUNTRIES, get_all_get_params(array('page', 'action', 'cID')).'action=setflag_all&flag=1&page='.$_GET['page']); ?>">alle aktivieren</a>
			<a class="button" href="<?php echo  href_link(FILENAME_COUNTRIES, get_all_get_params(array('page', 'action', 'cID')).'action=setflag_all&flag=0&page='.$_GET['page']); ?>">alle deaktivieren</a>
		</td>
	  </tr>
      <tr>
        <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
          <tr>
            <td valign="top"><table width="100%" cellspacing="0" cellpadding="0" class="dataTable">
              <tr class="dataTableHeadingRow">
                <td class="dataTableHeadingContent" colspan="2"><?php echo TABLE_HEADING_COUNTRY_NAME; ?></td>
                <td class="dataTableHeadingContent" align="center" colspan="2"><?php echo TABLE_HEADING_COUNTRY_CODES; ?></td>
                <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_STATUS; ?></td>
                <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?>&nbsp;</td>
              </tr>
				<?php
				  	$sql = "SELECT 
								countries_id,
								countries_name,
								countries_iso_code_2,
								countries_iso_code_3,
								status,
								address_format_id 
							FROM 
								".TABLE_COUNTRIES." 
							ORDER BY 
								countries_name";				
					$query = page_break_create($_POST['per_site'], $_GET['page'], $sql, 'countries.php');
				
					$countries = $query['query'];
				  while(!$countries->EOF) { $rows++;
				    if (((!$_GET['cID']) || (@$_GET['cID'] == $countries->fields['countries_id'])) && (!$cInfo) && (substr($_GET['action'], 0, 3) != 'new'))
				      $cInfo = new objectInfo($countries->fields);

				    if ( (is_object($cInfo)) && ($countries->fields['countries_id'] == $cInfo->countries_id) )
				      echo '<tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'pointer\'" onclick="document.location.href=\''.href_link(FILENAME_COUNTRIES, 'page='.$_GET['page'].'&cID='.$cInfo->countries_id.'&action=edit').'\'">'."\n";
				    else {
						if ($rows % 2 == 0)
				    		$f = 'dataTableRow';
				    	else
				    		$f = '';
				      echo '<tr class="'.$f.'" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'pointer\'" onmouseout="this.className=\''.$f.'\'" onclick="document.location.href=\''.href_link(FILENAME_COUNTRIES, 'page='.$_GET['page'].'&cID='.$countries->fields['countries_id']).'\'">'."\n";
				    }
					if(file_exists('images/flaggen/'.strtolower($countries->fields['countries_iso_code_2']).'.gif'))
						$flagge = '<img src="images/flaggen/'.strtolower($countries->fields['countries_iso_code_2']).'.gif" alt="'.$countries->fields['countries_iso_code_2'].'" />';
					else
						$flagge = '&nbsp;';
				?>
				<td align="center" valign="middle" width="1">
					<?php echo $flagge; ?>
				</td>
                <td><?php echo $countries->fields['countries_name']; ?></td>
                <td align="center" width="40"><?php echo $countries->fields['countries_iso_code_2']; ?></td>
                <td align="center" width="40"><?php echo $countries->fields['countries_iso_code_3']; ?></td>
                <td align="center">
				<?php
				      if ($countries->fields['status'] == '1') {
				        echo image(DIR_WS_IMAGES.'icon_status_green.gif', IMAGE_ICON_STATUS_GREEN).'&nbsp;&nbsp;<a href="'.href_link(FILENAME_COUNTRIES, get_all_get_params(array('page', 'action', 'cID')).'action=setlflag&flag=0&cID='.$countries->fields['countries_id'].'&page='.$_GET['page']).'">'.image(DIR_WS_IMAGES.'icon_status_red_light.gif', IMAGE_ICON_STATUS_RED_LIGHT).'</a>';
				      } else {
				        echo '<a href="'.href_link(FILENAME_COUNTRIES, get_all_get_params(array('page', 'action', 'cID')).'action=setlflag&flag=1&cID='.$countries->fields['countries_id'].'&page='.$_GET['page']).'">'.image(DIR_WS_IMAGES.'icon_status_green_light.gif', IMAGE_ICON_STATUS_GREEN_LIGHT).'</a>&nbsp;&nbsp;'.image(DIR_WS_IMAGES.'icon_status_red.gif', IMAGE_ICON_STATUS_RED);
				      }
				?>
                </td>
                <td align="right"><?php if ( (is_object($cInfo)) && ($countries->fields['countries_id'] == $cInfo->countries_id) ) { echo image(DIR_WS_IMAGES.'icon_arrow_right.gif', ''); } else { echo 				'<a href="'.href_link(FILENAME_COUNTRIES, 'page='.$_GET['page'].'&cID='.$countries->fields['countries_id']).'">'.image(DIR_WS_IMAGES.'icon_info.gif', IMAGE_ICON_INFO).'</a>'; } ?>&nbsp;</td>
				<?php
					echo '</tr>';
					$countries->MoveNext();
				  }
				?>
            </table>
			</td>
			<?php
			  $heading = array();
			  $contents = array();
			  switch ($_GET['action']) {
			    case 'new':
			      $heading[] = array('text' => '<b>'.TEXT_INFO_HEADING_NEW_COUNTRY.'</b>');

			      $contents = array('form' => draw_form('countries', FILENAME_COUNTRIES, 'page='.$_GET['page'].'&action=insert'));
			      $contents[] = array('text' => TEXT_INFO_INSERT_INTRO);
			      $contents[] = array('text' => '<br />'.TEXT_INFO_COUNTRY_NAME.'<br />'.draw_input_field('countries_name'));
			      $contents[] = array('text' => '<br />'.TEXT_INFO_COUNTRY_CODE_2.'<br />'.draw_input_field('countries_iso_code_2'));
			      $contents[] = array('text' => '<br />'.TEXT_INFO_COUNTRY_CODE_3.'<br />'.draw_input_field('countries_iso_code_3'));
			      $contents[] = array('text' => '<br />'.TEXT_INFO_ADDRESS_FORMAT.'<br />'.draw_pull_down_menu('address_format_id', get_address_formats()));
			      $contents[] = array('align' => 'center', 'text' => '<br /><button type="submit" class="button" onclick="this.blur();">'.BUTTON_INSERT.'</button>&nbsp;<a class="button" onClick="this.blur();" href="'.href_link(FILENAME_COUNTRIES, 'page='.$_GET['page']).'">'.BUTTON_CANCEL.'</a>');
			      break;
			    case 'edit':
			      $heading[] = array('text' => '<b>'.TEXT_INFO_HEADING_EDIT_COUNTRY.'</b>');

			      $contents = array('form' => draw_form('countries', FILENAME_COUNTRIES, 'page='.$_GET['page'].'&cID='.$cInfo->countries_id.'&action=save'));
			      $contents[] = array('text' => TEXT_INFO_EDIT_INTRO);
			      $contents[] = array('text' => '<br />'.TEXT_INFO_COUNTRY_NAME.'<br />'.draw_input_field('countries_name', $cInfo->countries_name));
			      $contents[] = array('text' => '<br />'.TEXT_INFO_COUNTRY_CODE_2.'<br />'.draw_input_field('countries_iso_code_2', $cInfo->countries_iso_code_2));
			      $contents[] = array('text' => '<br />'.TEXT_INFO_COUNTRY_CODE_3.'<br />'.draw_input_field('countries_iso_code_3', $cInfo->countries_iso_code_3));
			      $contents[] = array('text' => '<br />'.TEXT_INFO_ADDRESS_FORMAT.'<br />'.draw_pull_down_menu('address_format_id', get_address_formats(), $cInfo->address_format_id));
			      $contents[] = array('align' => 'center', 'text' => '<br /><button type="submit" class="button" onclick="this.blur();">'. BUTTON_UPDATE.'</button>&nbsp;<a class="button" onClick="this.blur();" href="'.href_link(FILENAME_COUNTRIES, 'page='.$_GET['page'].'&cID='.$cInfo->countries_id).'">'.BUTTON_CANCEL.'</a>');
			      break;
			    case 'delete':
			      $heading[] = array('text' => '<b>'.TEXT_INFO_HEADING_DELETE_COUNTRY.'</b>');

			      $contents = array('form' => draw_form('countries', FILENAME_COUNTRIES, 'page='.$_GET['page'].'&cID='.$cInfo->countries_id.'&action=deleteconfirm'));
			      $contents[] = array('text' => TEXT_INFO_DELETE_INTRO);
			      $contents[] = array('text' => '<br /><b>'.$cInfo->countries_name.'</b>');
			      $contents[] = array('align' => 'center', 'text' => '<br /><input type="submit" class="button" onClick="this.blur();" value="'.BUTTON_DELETE.'"/>&nbsp;<a class="button" onClick="this.blur();" href="'.href_link(FILENAME_COUNTRIES, 'page='.$_GET['page'].'&cID='.$cInfo->countries_id).'">'.BUTTON_CANCEL.'</a>');
			      break;
			    default:
			      if (is_object($cInfo)) {
			        $heading[] = array('text' => '<b>'.$cInfo->countries_name.'</b>');

			        $contents[] = array('align' => 'center', 'text' => '<a class="button" onClick="this.blur();" href="'.href_link(FILENAME_COUNTRIES, 'page='.$_GET['page'].'&cID='.$cInfo->countries_id.'&action=edit').'">'.BUTTON_EDIT.'</a> <a class="button" onClick="this.blur();" href="'.href_link(FILENAME_COUNTRIES, 'page='.$_GET['page'].'&cID='.$cInfo->countries_id.'&action=delete').'">'.BUTTON_DELETE.'</a>');
			        $contents[] = array('text' => '<br />'.TEXT_INFO_COUNTRY_NAME.'<br />'.$cInfo->countries_name);
			        $contents[] = array('text' => '<br />'.TEXT_INFO_COUNTRY_CODE_2.' '.$cInfo->countries_iso_code_2);
			        $contents[] = array('text' => '<br />'.TEXT_INFO_COUNTRY_CODE_3.' '.$cInfo->countries_iso_code_3);
			        $contents[] = array('text' => '<br />'.TEXT_INFO_ADDRESS_FORMAT.' '.$cInfo->address_format_id);
			      }
			      break;
			  }

			  if ( (not_null($heading)) && (not_null($contents)) ) {
			    echo '<td width="25%" class="border" valign="top">'."\n";
			    $box = new box;
			    echo $box->infoBox($heading, $contents);
			    echo '</td>'."\n";
			  }

			?>
          </tr>
		  <tr>
		  	<td colspan="2">
			<table border="0" width="100%" cellspacing="0" cellpadding="2">
           		<tr class="page_break">
				<td class="smallText" valign="top" width="33.3%"><?php echo 'Angezeigt werden '.$query['from'].' bis '.$query['to'].' (von insgesamt '.$query['total'].' Ländern)'; ?></td>
				<td class="smallText" align="center" width="33.3%"></td>
				<td class="smallText" align="right" width="33.3%">
					Länder pro Seite: <?php echo $query['page_break']->perSiteDropdown($_GET['page']); ?>
				</td>
			</tr>
			<tr><td align="center" colspan="3"><?php echo '<br />'.$query['links']; ?></td></tr>
			<?php
			 if (!$_GET['action']) {
			?>
              <tr>
                <td colspan="2" align="right"><?php echo '<a class="button" onClick="this.blur();" href="'.href_link(FILENAME_COUNTRIES, 'page='.$_GET['page'].'&action=new').'">'.BUTTON_NEW_COUNTRY.'</a>'; ?></td>
              </tr>
			<?php
			  }
			?>
            </table>
			</td>
		  </tr>
        </table></td>
      </tr>
    </table></td>
  </tr>
</table>
</div>
<?php require(DIR_WS_INCLUDES.'footer.php'); ?>
</body>
</html>
<?php require(DIR_WS_INCLUDES.'application_bottom.php'); ?>